﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="IPAMSDataSet" targetNamespace="http://tempuri.org/IPAMSDataSet.xsd" xmlns:mstns="http://tempuri.org/IPAMSDataSet.xsd" xmlns="http://tempuri.org/IPAMSDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="IPAMSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="IPAMSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.IPAMS.Data.Properties.Settings.GlobalReference.Default.IPAMSConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="IPAMSDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="IPAMSDataSet" msprop:Generator_DataSetName="IPAMSDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Action" msprop:Generator_UserTableName="Action" msprop:Generator_RowDeletedName="ActionRowDeleted" msprop:Generator_RowChangedName="ActionRowChanged" msprop:Generator_RowClassName="ActionRow" msprop:Generator_RowChangingName="ActionRowChanging" msprop:Generator_RowEvArgName="ActionRowChangeEvent" msprop:Generator_RowEvHandlerName="ActionRowChangeEventHandler" msprop:Generator_TableClassName="ActionDataTable" msprop:Generator_TableVarName="tableAction" msprop:Generator_RowDeletingName="ActionRowDeleting" msprop:Generator_TablePropName="Action">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CashAction" msprop:Generator_UserTableName="CashAction" msprop:Generator_RowDeletedName="CashActionRowDeleted" msprop:Generator_RowChangedName="CashActionRowChanged" msprop:Generator_RowClassName="CashActionRow" msprop:Generator_RowChangingName="CashActionRowChanging" msprop:Generator_RowEvArgName="CashActionRowChangeEvent" msprop:Generator_RowEvHandlerName="CashActionRowChangeEventHandler" msprop:Generator_TableClassName="CashActionDataTable" msprop:Generator_TableVarName="tableCashAction" msprop:Generator_RowDeletingName="CashActionRowDeleting" msprop:Generator_TablePropName="CashAction">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CashPortfolio" msprop:Generator_UserTableName="CashPortfolio" msprop:Generator_RowDeletedName="CashPortfolioRowDeleted" msprop:Generator_RowChangedName="CashPortfolioRowChanged" msprop:Generator_RowClassName="CashPortfolioRow" msprop:Generator_RowChangingName="CashPortfolioRowChanging" msprop:Generator_RowEvArgName="CashPortfolioRowChangeEvent" msprop:Generator_RowEvHandlerName="CashPortfolioRowChangeEventHandler" msprop:Generator_TableClassName="CashPortfolioDataTable" msprop:Generator_TableVarName="tableCashPortfolio" msprop:Generator_RowDeletingName="CashPortfolioRowDeleting" msprop:Generator_TablePropName="CashPortfolio">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CashTransaction" msprop:Generator_UserTableName="CashTransaction" msprop:Generator_RowDeletedName="CashTransactionRowDeleted" msprop:Generator_RowChangedName="CashTransactionRowChanged" msprop:Generator_RowClassName="CashTransactionRow" msprop:Generator_RowChangingName="CashTransactionRowChanging" msprop:Generator_RowEvArgName="CashTransactionRowChangeEvent" msprop:Generator_RowEvHandlerName="CashTransactionRowChangeEventHandler" msprop:Generator_TableClassName="CashTransactionDataTable" msprop:Generator_TableVarName="tableCashTransaction" msprop:Generator_RowDeletingName="CashTransactionRowDeleting" msprop:Generator_TablePropName="CashTransaction">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CashPotfolioID" msprop:Generator_UserColumnName="CashPotfolioID" msprop:Generator_ColumnPropNameInRow="CashPotfolioID" msprop:Generator_ColumnVarNameInTable="columnCashPotfolioID" msprop:Generator_ColumnPropNameInTable="CashPotfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionID" msprop:Generator_UserColumnName="ActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Amount" msprop:Generator_UserColumnName="Amount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInTable="AmountColumn" type="xs:int" />
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateTime" msprop:Generator_UserColumnName="DateTime" msprop:Generator_ColumnPropNameInRow="DateTime" msprop:Generator_ColumnVarNameInTable="columnDateTime" msprop:Generator_ColumnPropNameInTable="DateTimeColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Commission" msprop:Generator_UserTableName="Commission" msprop:Generator_RowDeletedName="CommissionRowDeleted" msprop:Generator_RowChangedName="CommissionRowChanged" msprop:Generator_RowClassName="CommissionRow" msprop:Generator_RowChangingName="CommissionRowChanging" msprop:Generator_RowEvArgName="CommissionRowChangeEvent" msprop:Generator_RowEvHandlerName="CommissionRowChangeEventHandler" msprop:Generator_TableClassName="CommissionDataTable" msprop:Generator_TableVarName="tableCommission" msprop:Generator_RowDeletingName="CommissionRowDeleting" msprop:Generator_TablePropName="Commission">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceID" msprop:Generator_UserColumnName="SourceID" msprop:Generator_ColumnPropNameInRow="SourceID" msprop:Generator_ColumnVarNameInTable="columnSourceID" msprop:Generator_ColumnPropNameInTable="SourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvestmentHouseID" msprop:Generator_UserColumnName="InvestmentHouseID" msprop:Generator_ColumnPropNameInRow="InvestmentHouseID" msprop:Generator_ColumnVarNameInTable="columnInvestmentHouseID" msprop:Generator_ColumnPropNameInTable="InvestmentHouseIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionID" msprop:Generator_UserColumnName="ActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Min" msprop:Generator_UserColumnName="Min" msprop:Generator_ColumnPropNameInRow="Min" msprop:Generator_ColumnVarNameInTable="columnMin" msprop:Generator_ColumnPropNameInTable="MinColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Max" msprop:Generator_UserColumnName="Max" msprop:Generator_ColumnPropNameInRow="Max" msprop:Generator_ColumnVarNameInTable="columnMax" msprop:Generator_ColumnPropNameInTable="MaxColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Rate" msprop:Generator_UserColumnName="Rate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInTable="RateColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PeriodMonths" msprop:Generator_UserColumnName="PeriodMonths" msprop:Generator_ColumnPropNameInRow="PeriodMonths" msprop:Generator_ColumnVarNameInTable="columnPeriodMonths" msprop:Generator_ColumnPropNameInTable="PeriodMonthsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="PerOneStock" msprop:Generator_UserColumnName="PerOneStock" msprop:Generator_ColumnPropNameInRow="PerOneStock" msprop:Generator_ColumnVarNameInTable="columnPerOneStock" msprop:Generator_ColumnPropNameInTable="PerOneStockColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValidFromDate" msprop:Generator_UserColumnName="ValidFromDate" msprop:Generator_ColumnPropNameInRow="ValidFromDate" msprop:Generator_ColumnVarNameInTable="columnValidFromDate" msprop:Generator_ColumnPropNameInTable="ValidFromDateColumn" type="xs:dateTime" />
              <xs:element name="ValidToDate" msprop:Generator_UserColumnName="ValidToDate" msprop:Generator_ColumnPropNameInRow="ValidToDate" msprop:Generator_ColumnVarNameInTable="columnValidToDate" msprop:Generator_ColumnPropNameInTable="ValidToDateColumn" type="xs:dateTime" />
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Country" msprop:Generator_UserTableName="Country" msprop:Generator_RowDeletedName="CountryRowDeleted" msprop:Generator_RowChangedName="CountryRowChanged" msprop:Generator_RowClassName="CountryRow" msprop:Generator_RowChangingName="CountryRowChanging" msprop:Generator_RowEvArgName="CountryRowChangeEvent" msprop:Generator_RowEvHandlerName="CountryRowChangeEventHandler" msprop:Generator_TableClassName="CountryDataTable" msprop:Generator_TableVarName="tableCountry" msprop:Generator_RowDeletingName="CountryRowDeleting" msprop:Generator_TablePropName="Country">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Currency" msprop:Generator_UserTableName="Currency" msprop:Generator_RowDeletedName="CurrencyRowDeleted" msprop:Generator_RowChangedName="CurrencyRowChanged" msprop:Generator_RowClassName="CurrencyRow" msprop:Generator_RowChangingName="CurrencyRowChanging" msprop:Generator_RowEvArgName="CurrencyRowChangeEvent" msprop:Generator_RowEvHandlerName="CurrencyRowChangeEventHandler" msprop:Generator_TableClassName="CurrencyDataTable" msprop:Generator_TableVarName="tableCurrency" msprop:Generator_RowDeletingName="CurrencyRowDeleting" msprop:Generator_TablePropName="Currency">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DividendsQuote" msprop:Generator_UserTableName="DividendsQuote" msprop:Generator_RowDeletedName="DividendsQuoteRowDeleted" msprop:Generator_RowChangedName="DividendsQuoteRowChanged" msprop:Generator_RowClassName="DividendsQuoteRow" msprop:Generator_RowChangingName="DividendsQuoteRowChanging" msprop:Generator_RowEvArgName="DividendsQuoteRowChangeEvent" msprop:Generator_RowEvHandlerName="DividendsQuoteRowChangeEventHandler" msprop:Generator_TableClassName="DividendsQuoteDataTable" msprop:Generator_TableVarName="tableDividendsQuote" msprop:Generator_RowDeletingName="DividendsQuoteRowDeleting" msprop:Generator_TablePropName="DividendsQuote">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PaperID" msprop:Generator_UserColumnName="PaperID" msprop:Generator_ColumnPropNameInRow="PaperID" msprop:Generator_ColumnVarNameInTable="columnPaperID" msprop:Generator_ColumnPropNameInTable="PaperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExDate" msprop:Generator_UserColumnName="ExDate" msprop:Generator_ColumnPropNameInRow="ExDate" msprop:Generator_ColumnVarNameInTable="columnExDate" msprop:Generator_ColumnPropNameInTable="ExDateColumn" type="xs:dateTime" />
              <xs:element name="Value" msprop:Generator_UserColumnName="Value" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInTable="ValueColumn" type="xs:decimal" />
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ExchangeRatesQuote" msprop:Generator_UserTableName="ExchangeRatesQuote" msprop:Generator_RowDeletedName="ExchangeRatesQuoteRowDeleted" msprop:Generator_RowChangedName="ExchangeRatesQuoteRowChanged" msprop:Generator_RowClassName="ExchangeRatesQuoteRow" msprop:Generator_RowChangingName="ExchangeRatesQuoteRowChanging" msprop:Generator_RowEvArgName="ExchangeRatesQuoteRowChangeEvent" msprop:Generator_RowEvHandlerName="ExchangeRatesQuoteRowChangeEventHandler" msprop:Generator_TableClassName="ExchangeRatesQuoteDataTable" msprop:Generator_TableVarName="tableExchangeRatesQuote" msprop:Generator_RowDeletingName="ExchangeRatesQuoteRowDeleting" msprop:Generator_TablePropName="ExchangeRatesQuote">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SourceCurrencyCode" msprop:Generator_UserColumnName="SourceCurrencyCode" msprop:Generator_ColumnPropNameInRow="SourceCurrencyCode" msprop:Generator_ColumnVarNameInTable="columnSourceCurrencyCode" msprop:Generator_ColumnPropNameInTable="SourceCurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TargetCurrencyCode" msprop:Generator_UserColumnName="TargetCurrencyCode" msprop:Generator_ColumnPropNameInRow="TargetCurrencyCode" msprop:Generator_ColumnVarNameInTable="columnTargetCurrencyCode" msprop:Generator_ColumnPropNameInTable="TargetCurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" />
              <xs:element name="Rate" msprop:Generator_UserColumnName="Rate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInTable="RateColumn" type="xs:decimal" />
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InvestmentHouse" msprop:Generator_UserTableName="InvestmentHouse" msprop:Generator_RowDeletedName="InvestmentHouseRowDeleted" msprop:Generator_RowChangedName="InvestmentHouseRowChanged" msprop:Generator_RowClassName="InvestmentHouseRow" msprop:Generator_RowChangingName="InvestmentHouseRowChanging" msprop:Generator_RowEvArgName="InvestmentHouseRowChangeEvent" msprop:Generator_RowEvHandlerName="InvestmentHouseRowChangeEventHandler" msprop:Generator_TableClassName="InvestmentHouseDataTable" msprop:Generator_TableVarName="tableInvestmentHouse" msprop:Generator_RowDeletingName="InvestmentHouseRowDeleting" msprop:Generator_TablePropName="InvestmentHouse">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="URL" msprop:Generator_UserColumnName="URL" msprop:Generator_ColumnPropNameInRow="URL" msprop:Generator_ColumnVarNameInTable="columnURL" msprop:Generator_ColumnPropNameInTable="URLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Manager" msprop:Generator_UserTableName="Manager" msprop:Generator_RowDeletedName="ManagerRowDeleted" msprop:Generator_RowChangedName="ManagerRowChanged" msprop:Generator_RowClassName="ManagerRow" msprop:Generator_RowChangingName="ManagerRowChanging" msprop:Generator_RowEvArgName="ManagerRowChangeEvent" msprop:Generator_RowEvHandlerName="ManagerRowChangeEventHandler" msprop:Generator_TableClassName="ManagerDataTable" msprop:Generator_TableVarName="tableManager" msprop:Generator_RowDeletingName="ManagerRowDeleting" msprop:Generator_TablePropName="Manager">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MobilePhone" msprop:Generator_UserColumnName="MobilePhone" msprop:Generator_ColumnPropNameInRow="MobilePhone" msprop:Generator_ColumnVarNameInTable="columnMobilePhone" msprop:Generator_ColumnPropNameInTable="MobilePhoneColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Package" msprop:Generator_UserTableName="Package" msprop:Generator_RowDeletedName="PackageRowDeleted" msprop:Generator_RowChangedName="PackageRowChanged" msprop:Generator_RowClassName="PackageRow" msprop:Generator_RowChangingName="PackageRowChanging" msprop:Generator_RowEvArgName="PackageRowChangeEvent" msprop:Generator_RowEvHandlerName="PackageRowChangeEventHandler" msprop:Generator_TableClassName="PackageDataTable" msprop:Generator_TableVarName="tablePackage" msprop:Generator_RowDeletingName="PackageRowDeleting" msprop:Generator_TablePropName="Package">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceID" msprop:Generator_UserColumnName="SourceID" msprop:Generator_ColumnPropNameInRow="SourceID" msprop:Generator_ColumnVarNameInTable="columnSourceID" msprop:Generator_ColumnPropNameInTable="SourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateTime" msprop:Generator_UserColumnName="DateTime" msprop:Generator_ColumnPropNameInRow="DateTime" msprop:Generator_ColumnVarNameInTable="columnDateTime" msprop:Generator_ColumnPropNameInTable="DateTimeColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Paper" msprop:Generator_UserTableName="Paper" msprop:Generator_RowDeletedName="PaperRowDeleted" msprop:Generator_RowChangedName="PaperRowChanged" msprop:Generator_RowClassName="PaperRow" msprop:Generator_RowChangingName="PaperRowChanging" msprop:Generator_RowEvArgName="PaperRowChangeEvent" msprop:Generator_RowEvHandlerName="PaperRowChangeEventHandler" msprop:Generator_TableClassName="PaperDataTable" msprop:Generator_TableVarName="tablePaper" msprop:Generator_RowDeletingName="PaperRowDeleting" msprop:Generator_TablePropName="Paper">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Symbol" msprop:Generator_UserColumnName="Symbol" msprop:Generator_ColumnPropNameInRow="Symbol" msprop:Generator_ColumnVarNameInTable="columnSymbol" msprop:Generator_ColumnPropNameInTable="SymbolColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StockExchangeCode" msprop:Generator_UserColumnName="StockExchangeCode" msprop:Generator_ColumnPropNameInRow="StockExchangeCode" msprop:Generator_ColumnVarNameInTable="columnStockExchangeCode" msprop:Generator_ColumnPropNameInTable="StockExchangeCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Portfolio" msprop:Generator_UserTableName="Portfolio" msprop:Generator_RowDeletedName="PortfolioRowDeleted" msprop:Generator_RowChangedName="PortfolioRowChanged" msprop:Generator_RowClassName="PortfolioRow" msprop:Generator_RowChangingName="PortfolioRowChanging" msprop:Generator_RowEvArgName="PortfolioRowChangeEvent" msprop:Generator_RowEvHandlerName="PortfolioRowChangeEventHandler" msprop:Generator_TableClassName="PortfolioDataTable" msprop:Generator_TableVarName="tablePortfolio" msprop:Generator_RowDeletingName="PortfolioRowDeleting" msprop:Generator_TablePropName="Portfolio">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvestmentHouseID" msprop:Generator_UserColumnName="InvestmentHouseID" msprop:Generator_ColumnPropNameInRow="InvestmentHouseID" msprop:Generator_ColumnVarNameInTable="columnInvestmentHouseID" msprop:Generator_ColumnPropNameInTable="InvestmentHouseIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManagerId" msprop:Generator_UserColumnName="ManagerId" msprop:Generator_ColumnPropNameInRow="ManagerId" msprop:Generator_ColumnVarNameInTable="columnManagerId" msprop:Generator_ColumnPropNameInTable="ManagerIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TypeID" msprop:Generator_UserColumnName="TypeID" msprop:Generator_ColumnPropNameInRow="TypeID" msprop:Generator_ColumnVarNameInTable="columnTypeID" msprop:Generator_ColumnPropNameInTable="TypeIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QuantityPortfolioID" msprop:Generator_UserColumnName="QuantityPortfolioID" msprop:Generator_ColumnPropNameInRow="QuantityPortfolioID" msprop:Generator_ColumnVarNameInTable="columnQuantityPortfolioID" msprop:Generator_ColumnPropNameInTable="QuantityPortfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaxesSourceID" msprop:Generator_UserColumnName="TaxesSourceID" msprop:Generator_ColumnPropNameInRow="TaxesSourceID" msprop:Generator_ColumnVarNameInTable="columnTaxesSourceID" msprop:Generator_ColumnPropNameInTable="TaxesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CommissionsSourceID" msprop:Generator_UserColumnName="CommissionsSourceID" msprop:Generator_ColumnPropNameInRow="CommissionsSourceID" msprop:Generator_ColumnVarNameInTable="columnCommissionsSourceID" msprop:Generator_ColumnPropNameInTable="CommissionsSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StocksQuotesSourceID" msprop:Generator_UserColumnName="StocksQuotesSourceID" msprop:Generator_ColumnPropNameInRow="StocksQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnStocksQuotesSourceID" msprop:Generator_ColumnPropNameInTable="StocksQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DividendQuotesSourceID" msprop:Generator_UserColumnName="DividendQuotesSourceID" msprop:Generator_ColumnPropNameInRow="DividendQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnDividendQuotesSourceID" msprop:Generator_ColumnPropNameInTable="DividendQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExchangeRatesQuotesSourceID" msprop:Generator_UserColumnName="ExchangeRatesQuotesSourceID" msprop:Generator_ColumnPropNameInRow="ExchangeRatesQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnExchangeRatesQuotesSourceID" msprop:Generator_ColumnPropNameInTable="ExchangeRatesQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NotStocksQuotesSourceID" msprop:Generator_UserColumnName="NotStocksQuotesSourceID" msprop:Generator_ColumnPropNameInRow="NotStocksQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnNotStocksQuotesSourceID" msprop:Generator_ColumnPropNameInTable="NotStocksQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CashPortfolioID" msprop:Generator_UserColumnName="CashPortfolioID" msprop:Generator_ColumnPropNameInRow="CashPortfolioID" msprop:Generator_ColumnVarNameInTable="columnCashPortfolioID" msprop:Generator_ColumnPropNameInTable="CashPortfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PortfolioType" msprop:Generator_UserTableName="PortfolioType" msprop:Generator_RowDeletedName="PortfolioTypeRowDeleted" msprop:Generator_RowChangedName="PortfolioTypeRowChanged" msprop:Generator_RowClassName="PortfolioTypeRow" msprop:Generator_RowChangingName="PortfolioTypeRowChanging" msprop:Generator_RowEvArgName="PortfolioTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="PortfolioTypeRowChangeEventHandler" msprop:Generator_TableClassName="PortfolioTypeDataTable" msprop:Generator_TableVarName="tablePortfolioType" msprop:Generator_RowDeletingName="PortfolioTypeRowDeleting" msprop:Generator_TablePropName="PortfolioType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QuantityPortfolio" msprop:Generator_UserTableName="QuantityPortfolio" msprop:Generator_RowDeletedName="QuantityPortfolioRowDeleted" msprop:Generator_RowChangedName="QuantityPortfolioRowChanged" msprop:Generator_RowClassName="QuantityPortfolioRow" msprop:Generator_RowChangingName="QuantityPortfolioRowChanging" msprop:Generator_RowEvArgName="QuantityPortfolioRowChangeEvent" msprop:Generator_RowEvHandlerName="QuantityPortfolioRowChangeEventHandler" msprop:Generator_TableClassName="QuantityPortfolioDataTable" msprop:Generator_TableVarName="tableQuantityPortfolio" msprop:Generator_RowDeletingName="QuantityPortfolioRowDeleting" msprop:Generator_TablePropName="QuantityPortfolio">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QuantityTransaction" msprop:Generator_UserTableName="QuantityTransaction" msprop:Generator_RowDeletedName="QuantityTransactionRowDeleted" msprop:Generator_RowChangedName="QuantityTransactionRowChanged" msprop:Generator_RowClassName="QuantityTransactionRow" msprop:Generator_RowChangingName="QuantityTransactionRowChanging" msprop:Generator_RowEvArgName="QuantityTransactionRowChangeEvent" msprop:Generator_RowEvHandlerName="QuantityTransactionRowChangeEventHandler" msprop:Generator_TableClassName="QuantityTransactionDataTable" msprop:Generator_TableVarName="tableQuantityTransaction" msprop:Generator_RowDeletingName="QuantityTransactionRowDeleting" msprop:Generator_TablePropName="QuantityTransaction">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="QuantityPortfolioID" msprop:Generator_UserColumnName="QuantityPortfolioID" msprop:Generator_ColumnPropNameInRow="QuantityPortfolioID" msprop:Generator_ColumnVarNameInTable="columnQuantityPortfolioID" msprop:Generator_ColumnPropNameInTable="QuantityPortfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PaperID" msprop:Generator_UserColumnName="PaperID" msprop:Generator_ColumnPropNameInRow="PaperID" msprop:Generator_ColumnVarNameInTable="columnPaperID" msprop:Generator_ColumnPropNameInTable="PaperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionID" msprop:Generator_UserColumnName="ActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValueDate" msprop:Generator_UserColumnName="ValueDate" msprop:Generator_ColumnPropNameInRow="ValueDate" msprop:Generator_ColumnVarNameInTable="columnValueDate" msprop:Generator_ColumnPropNameInTable="ValueDateColumn" type="xs:dateTime" />
              <xs:element name="Quantity" msprop:Generator_UserColumnName="Quantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Source" msprop:Generator_UserTableName="Source" msprop:Generator_RowDeletedName="SourceRowDeleted" msprop:Generator_RowChangedName="SourceRowChanged" msprop:Generator_RowClassName="SourceRow" msprop:Generator_RowChangingName="SourceRowChanging" msprop:Generator_RowEvArgName="SourceRowChangeEvent" msprop:Generator_RowEvHandlerName="SourceRowChangeEventHandler" msprop:Generator_TableClassName="SourceDataTable" msprop:Generator_TableVarName="tableSource" msprop:Generator_RowDeletingName="SourceRowDeleting" msprop:Generator_TablePropName="Source">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Location" msprop:Generator_UserColumnName="Location" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInTable="LocationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StockExchange" msprop:Generator_UserTableName="StockExchange" msprop:Generator_RowDeletedName="StockExchangeRowDeleted" msprop:Generator_RowChangedName="StockExchangeRowChanged" msprop:Generator_RowClassName="StockExchangeRow" msprop:Generator_RowChangingName="StockExchangeRowChanging" msprop:Generator_RowEvArgName="StockExchangeRowChangeEvent" msprop:Generator_RowEvHandlerName="StockExchangeRowChangeEventHandler" msprop:Generator_TableClassName="StockExchangeDataTable" msprop:Generator_TableVarName="tableStockExchange" msprop:Generator_RowDeletingName="StockExchangeRowDeleting" msprop:Generator_TablePropName="StockExchange">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StocksQuote" msprop:Generator_UserTableName="StocksQuote" msprop:Generator_RowDeletedName="StocksQuoteRowDeleted" msprop:Generator_RowChangedName="StocksQuoteRowChanged" msprop:Generator_RowClassName="StocksQuoteRow" msprop:Generator_RowChangingName="StocksQuoteRowChanging" msprop:Generator_RowEvArgName="StocksQuoteRowChangeEvent" msprop:Generator_RowEvHandlerName="StocksQuoteRowChangeEventHandler" msprop:Generator_TableClassName="StocksQuoteDataTable" msprop:Generator_TableVarName="tableStocksQuote" msprop:Generator_RowDeletingName="StocksQuoteRowDeleting" msprop:Generator_TablePropName="StocksQuote">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PaperID" msprop:Generator_UserColumnName="PaperID" msprop:Generator_ColumnPropNameInRow="PaperID" msprop:Generator_ColumnVarNameInTable="columnPaperID" msprop:Generator_ColumnPropNameInTable="PaperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" />
              <xs:element name="ClosingRate" msprop:Generator_UserColumnName="ClosingRate" msprop:Generator_ColumnPropNameInRow="ClosingRate" msprop:Generator_ColumnVarNameInTable="columnClosingRate" msprop:Generator_ColumnPropNameInTable="ClosingRateColumn" type="xs:decimal" />
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tax" msprop:Generator_UserTableName="Tax" msprop:Generator_RowDeletedName="TaxRowDeleted" msprop:Generator_RowChangedName="TaxRowChanged" msprop:Generator_RowClassName="TaxRow" msprop:Generator_RowChangingName="TaxRowChanging" msprop:Generator_RowEvArgName="TaxRowChangeEvent" msprop:Generator_RowEvHandlerName="TaxRowChangeEventHandler" msprop:Generator_TableClassName="TaxDataTable" msprop:Generator_TableVarName="tableTax" msprop:Generator_RowDeletingName="TaxRowDeleting" msprop:Generator_TablePropName="Tax">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionId" msprop:Generator_UserColumnName="ActionId" msprop:Generator_ColumnPropNameInRow="ActionId" msprop:Generator_ColumnVarNameInTable="columnActionId" msprop:Generator_ColumnPropNameInTable="ActionIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rate" msprop:Generator_UserColumnName="Rate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInTable="RateColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValidFromDate" msprop:Generator_UserColumnName="ValidFromDate" msprop:Generator_ColumnPropNameInRow="ValidFromDate" msprop:Generator_ColumnVarNameInTable="columnValidFromDate" msprop:Generator_ColumnPropNameInTable="ValidFromDateColumn" type="xs:dateTime" />
              <xs:element name="ValidToDate" msprop:Generator_UserColumnName="ValidToDate" msprop:Generator_ColumnPropNameInRow="ValidToDate" msprop:Generator_ColumnVarNameInTable="columnValidToDate" msprop:Generator_ColumnPropNameInTable="ValidToDateColumn" type="xs:dateTime" />
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Action" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="CashAction_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CashAction" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="CashPortfolio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CashPortfolio" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="CashTransaction_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CashTransaction" />
      <xs:field xpath="mstns:TransactionID" />
    </xs:unique>
    <xs:unique name="Commission_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Commission" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Country_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Country" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="Currency_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Currency" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="DividendsQuote_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DividendsQuote" />
      <xs:field xpath="mstns:PaperID" />
      <xs:field xpath="mstns:ExDate" />
      <xs:field xpath="mstns:PackageID" />
    </xs:unique>
    <xs:unique name="ExchangeRatesQuote_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ExchangeRatesQuote" />
      <xs:field xpath="mstns:SourceCurrencyCode" />
      <xs:field xpath="mstns:TargetCurrencyCode" />
      <xs:field xpath="mstns:Date" />
      <xs:field xpath="mstns:PackageID" />
    </xs:unique>
    <xs:unique name="InvestmentHouse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:InvestmentHouse" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Manager_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Manager" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Package_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Package" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Paper_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Paper" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Portfolio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="PortfolioType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PortfolioType" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="QuantityPortfolio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QuantityPortfolio" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="QuantityTransaction_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QuantityTransaction" />
      <xs:field xpath="mstns:TransactionID" />
    </xs:unique>
    <xs:unique name="Source_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Source" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="StockExchange_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StockExchange" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="StocksQuote_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StocksQuote" />
      <xs:field xpath="mstns:PaperID" />
      <xs:field xpath="mstns:Date" />
      <xs:field xpath="mstns:PackageID" />
    </xs:unique>
    <xs:unique name="Tax_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tax" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:keyref name="FK_Tax_Action" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_Tax_Action" msprop:rel_Generator_RelationVarName="relationFK_Tax_Action" msprop:rel_Generator_UserChildTable="Tax" msprop:rel_Generator_UserParentTable="Action" msprop:rel_Generator_ParentPropName="ActionRow" msprop:rel_Generator_ChildPropName="GetTaxRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Tax" />
      <xs:field xpath="mstns:ActionId" />
    </xs:keyref>
    <xs:keyref name="FK_Tax_Country" refer="Country_Constraint1" msprop:rel_Generator_UserRelationName="FK_Tax_Country" msprop:rel_Generator_RelationVarName="relationFK_Tax_Country" msprop:rel_Generator_UserChildTable="Tax" msprop:rel_Generator_UserParentTable="Country" msprop:rel_Generator_ParentPropName="CountryRow" msprop:rel_Generator_ChildPropName="GetTaxRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Tax" />
      <xs:field xpath="mstns:CountryCode" />
    </xs:keyref>
    <xs:keyref name="FK_Tax_Package" refer="Package_Constraint1" msprop:rel_Generator_UserRelationName="FK_Tax_Package" msprop:rel_Generator_RelationVarName="relationFK_Tax_Package" msprop:rel_Generator_UserChildTable="Tax" msprop:rel_Generator_UserParentTable="Package" msprop:rel_Generator_ParentPropName="PackageRow" msprop:rel_Generator_ChildPropName="GetTaxRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Tax" />
      <xs:field xpath="mstns:PackageID" />
    </xs:keyref>
    <xs:keyref name="FK_StocksQuote_Package" refer="Package_Constraint1" msprop:rel_Generator_UserRelationName="FK_StocksQuote_Package" msprop:rel_Generator_RelationVarName="relationFK_StocksQuote_Package" msprop:rel_Generator_UserChildTable="StocksQuote" msprop:rel_Generator_UserParentTable="Package" msprop:rel_Generator_ParentPropName="PackageRow" msprop:rel_Generator_ChildPropName="GetStocksQuoteRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:StocksQuote" />
      <xs:field xpath="mstns:PackageID" />
    </xs:keyref>
    <xs:keyref name="FK_StocksQuote_Paper" refer="Paper_Constraint1" msprop:rel_Generator_UserRelationName="FK_StocksQuote_Paper" msprop:rel_Generator_RelationVarName="relationFK_StocksQuote_Paper" msprop:rel_Generator_UserChildTable="StocksQuote" msprop:rel_Generator_UserParentTable="Paper" msprop:rel_Generator_ParentPropName="PaperRow" msprop:rel_Generator_ChildPropName="GetStocksQuoteRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:StocksQuote" />
      <xs:field xpath="mstns:PaperID" />
    </xs:keyref>
    <xs:keyref name="FK_StockExchange_Country" refer="Country_Constraint1" msprop:rel_Generator_UserRelationName="FK_StockExchange_Country" msprop:rel_Generator_RelationVarName="relationFK_StockExchange_Country" msprop:rel_Generator_UserChildTable="StockExchange" msprop:rel_Generator_UserParentTable="Country" msprop:rel_Generator_ParentPropName="CountryRow" msprop:rel_Generator_ChildPropName="GetStockExchangeRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:StockExchange" />
      <xs:field xpath="mstns:CountryCode" />
    </xs:keyref>
    <xs:keyref name="FK_QuantityTransaction_Action" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_QuantityTransaction_Action" msprop:rel_Generator_RelationVarName="relationFK_QuantityTransaction_Action" msprop:rel_Generator_UserChildTable="QuantityTransaction" msprop:rel_Generator_UserParentTable="Action" msprop:rel_Generator_ParentPropName="ActionRow" msprop:rel_Generator_ChildPropName="GetQuantityTransactionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:QuantityTransaction" />
      <xs:field xpath="mstns:ActionID" />
    </xs:keyref>
    <xs:keyref name="FK_QuantityTransaction_Package" refer="Package_Constraint1" msprop:rel_Generator_UserRelationName="FK_QuantityTransaction_Package" msprop:rel_Generator_RelationVarName="relationFK_QuantityTransaction_Package" msprop:rel_Generator_UserChildTable="QuantityTransaction" msprop:rel_Generator_UserParentTable="Package" msprop:rel_Generator_ParentPropName="PackageRow" msprop:rel_Generator_ChildPropName="GetQuantityTransactionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:QuantityTransaction" />
      <xs:field xpath="mstns:PackageID" />
    </xs:keyref>
    <xs:keyref name="FK_QuantityTransaction_Paper" refer="Paper_Constraint1" msprop:rel_Generator_UserRelationName="FK_QuantityTransaction_Paper" msprop:rel_Generator_RelationVarName="relationFK_QuantityTransaction_Paper" msprop:rel_Generator_UserChildTable="QuantityTransaction" msprop:rel_Generator_UserParentTable="Paper" msprop:rel_Generator_ParentPropName="PaperRow" msprop:rel_Generator_ChildPropName="GetQuantityTransactionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:QuantityTransaction" />
      <xs:field xpath="mstns:PaperID" />
    </xs:keyref>
    <xs:keyref name="FK_QuantityTransaction_QuantityPortfolio" refer="QuantityPortfolio_Constraint1" msprop:rel_Generator_UserRelationName="FK_QuantityTransaction_QuantityPortfolio" msprop:rel_Generator_RelationVarName="relationFK_QuantityTransaction_QuantityPortfolio" msprop:rel_Generator_UserChildTable="QuantityTransaction" msprop:rel_Generator_UserParentTable="QuantityPortfolio" msprop:rel_Generator_ParentPropName="QuantityPortfolioRow" msprop:rel_Generator_ChildPropName="GetQuantityTransactionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:QuantityTransaction" />
      <xs:field xpath="mstns:QuantityPortfolioID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_CashPortfolio" refer="CashPortfolio_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_CashPortfolio" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_CashPortfolio" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="CashPortfolio" msprop:rel_Generator_ParentPropName="CashPortfolioRow" msprop:rel_Generator_ChildPropName="GetPortfolioRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:CashPortfolioID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Currency" refer="Currency_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Currency" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Currency" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Currency" msprop:rel_Generator_ParentPropName="CurrencyRow" msprop:rel_Generator_ChildPropName="GetPortfolioRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:CurrencyCode" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_InvestmentHouse" refer="InvestmentHouse_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_InvestmentHouse" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_InvestmentHouse" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="InvestmentHouse" msprop:rel_Generator_ParentPropName="InvestmentHouseRow" msprop:rel_Generator_ChildPropName="GetPortfolioRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:InvestmentHouseID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Manager" refer="Manager_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Manager" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Manager" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Manager" msprop:rel_Generator_ParentPropName="ManagerRow" msprop:rel_Generator_ChildPropName="GetPortfolioRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:ManagerId" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_PortfolioType" refer="PortfolioType_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_PortfolioType" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_PortfolioType" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="PortfolioType" msprop:rel_Generator_ParentPropName="PortfolioTypeRow" msprop:rel_Generator_ChildPropName="GetPortfolioRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:TypeID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_QuantityPortfolio" refer="QuantityPortfolio_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_QuantityPortfolio" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_QuantityPortfolio" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="QuantityPortfolio" msprop:rel_Generator_ParentPropName="QuantityPortfolioRow" msprop:rel_Generator_ChildPropName="GetPortfolioRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:QuantityPortfolioID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Source" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Source" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Source" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRowByFK_Portfolio_Source" msprop:rel_Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:TaxesSourceID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Source1" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Source1" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Source1" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRowByFK_Portfolio_Source1" msprop:rel_Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source1" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:CommissionsSourceID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Source2" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Source2" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Source2" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRowByFK_Portfolio_Source2" msprop:rel_Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source2" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:StocksQuotesSourceID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Source3" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Source3" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Source3" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRowByFK_Portfolio_Source3" msprop:rel_Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source3" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:DividendQuotesSourceID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Source4" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Source4" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Source4" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRowByFK_Portfolio_Source4" msprop:rel_Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source4" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:ExchangeRatesQuotesSourceID" />
    </xs:keyref>
    <xs:keyref name="FK_Portfolio_Source5" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Portfolio_Source5" msprop:rel_Generator_RelationVarName="relationFK_Portfolio_Source5" msprop:rel_Generator_UserChildTable="Portfolio" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRowByFK_Portfolio_Source5" msprop:rel_Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source5" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:NotStocksQuotesSourceID" />
    </xs:keyref>
    <xs:keyref name="FK_Paper_StockExchange" refer="StockExchange_Constraint1" msprop:rel_Generator_UserRelationName="FK_Paper_StockExchange" msprop:rel_Generator_RelationVarName="relationFK_Paper_StockExchange" msprop:rel_Generator_UserChildTable="Paper" msprop:rel_Generator_UserParentTable="StockExchange" msprop:rel_Generator_ParentPropName="StockExchangeRow" msprop:rel_Generator_ChildPropName="GetPaperRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Paper" />
      <xs:field xpath="mstns:StockExchangeCode" />
    </xs:keyref>
    <xs:keyref name="FK_Package_Source" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Package_Source" msprop:rel_Generator_RelationVarName="relationFK_Package_Source" msprop:rel_Generator_UserChildTable="Package" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRow" msprop:rel_Generator_ChildPropName="GetPackageRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Package" />
      <xs:field xpath="mstns:SourceID" />
    </xs:keyref>
    <xs:keyref name="FK_ExchangeRatesQuote_Currency" refer="Currency_Constraint1" msprop:rel_Generator_UserRelationName="FK_ExchangeRatesQuote_Currency" msprop:rel_Generator_RelationVarName="relationFK_ExchangeRatesQuote_Currency" msprop:rel_Generator_UserChildTable="ExchangeRatesQuote" msprop:rel_Generator_UserParentTable="Currency" msprop:rel_Generator_ParentPropName="CurrencyRowByFK_ExchangeRatesQuote_Currency" msprop:rel_Generator_ChildPropName="GetExchangeRatesQuoteRowsByFK_ExchangeRatesQuote_Currency" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:ExchangeRatesQuote" />
      <xs:field xpath="mstns:SourceCurrencyCode" />
    </xs:keyref>
    <xs:keyref name="FK_ExchangeRatesQuote_Currency1" refer="Currency_Constraint1" msprop:rel_Generator_UserRelationName="FK_ExchangeRatesQuote_Currency1" msprop:rel_Generator_RelationVarName="relationFK_ExchangeRatesQuote_Currency1" msprop:rel_Generator_UserChildTable="ExchangeRatesQuote" msprop:rel_Generator_UserParentTable="Currency" msprop:rel_Generator_ParentPropName="CurrencyRowByFK_ExchangeRatesQuote_Currency1" msprop:rel_Generator_ChildPropName="GetExchangeRatesQuoteRowsByFK_ExchangeRatesQuote_Currency1" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:ExchangeRatesQuote" />
      <xs:field xpath="mstns:TargetCurrencyCode" />
    </xs:keyref>
    <xs:keyref name="FK_ExchangeRatesQuote_Package" refer="Package_Constraint1" msprop:rel_Generator_UserRelationName="FK_ExchangeRatesQuote_Package" msprop:rel_Generator_RelationVarName="relationFK_ExchangeRatesQuote_Package" msprop:rel_Generator_UserChildTable="ExchangeRatesQuote" msprop:rel_Generator_UserParentTable="Package" msprop:rel_Generator_ParentPropName="PackageRow" msprop:rel_Generator_ChildPropName="GetExchangeRatesQuoteRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:ExchangeRatesQuote" />
      <xs:field xpath="mstns:PackageID" />
    </xs:keyref>
    <xs:keyref name="FK_DividendsQuote_Package" refer="Package_Constraint1" msprop:rel_Generator_UserRelationName="FK_DividendsQuote_Package" msprop:rel_Generator_RelationVarName="relationFK_DividendsQuote_Package" msprop:rel_Generator_UserChildTable="DividendsQuote" msprop:rel_Generator_UserParentTable="Package" msprop:rel_Generator_ParentPropName="PackageRow" msprop:rel_Generator_ChildPropName="GetDividendsQuoteRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:DividendsQuote" />
      <xs:field xpath="mstns:PackageID" />
    </xs:keyref>
    <xs:keyref name="FK_DividendsQuote_Paper" refer="Paper_Constraint1" msprop:rel_Generator_UserRelationName="FK_DividendsQuote_Paper" msprop:rel_Generator_RelationVarName="relationFK_DividendsQuote_Paper" msprop:rel_Generator_UserChildTable="DividendsQuote" msprop:rel_Generator_UserParentTable="Paper" msprop:rel_Generator_ParentPropName="PaperRow" msprop:rel_Generator_ChildPropName="GetDividendsQuoteRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:DividendsQuote" />
      <xs:field xpath="mstns:PaperID" />
    </xs:keyref>
    <xs:keyref name="FK_Country_Currency" refer="Currency_Constraint1" msprop:rel_Generator_UserRelationName="FK_Country_Currency" msprop:rel_Generator_RelationVarName="relationFK_Country_Currency" msprop:rel_Generator_UserChildTable="Country" msprop:rel_Generator_UserParentTable="Currency" msprop:rel_Generator_ParentPropName="CurrencyRow" msprop:rel_Generator_ChildPropName="GetCountryRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Country" />
      <xs:field xpath="mstns:CurrencyCode" />
    </xs:keyref>
    <xs:keyref name="FK_Commission_Source" refer="Source_Constraint1" msprop:rel_Generator_UserRelationName="FK_Commission_Source" msprop:rel_Generator_RelationVarName="relationFK_Commission_Source" msprop:rel_Generator_UserChildTable="Commission" msprop:rel_Generator_UserParentTable="Source" msprop:rel_Generator_ParentPropName="SourceRow" msprop:rel_Generator_ChildPropName="GetCommissionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Commission" />
      <xs:field xpath="mstns:SourceID" />
    </xs:keyref>
    <xs:keyref name="FK_Commission_InvestmentHouse" refer="InvestmentHouse_Constraint1" msprop:rel_Generator_UserRelationName="FK_Commission_InvestmentHouse" msprop:rel_Generator_RelationVarName="relationFK_Commission_InvestmentHouse" msprop:rel_Generator_UserChildTable="Commission" msprop:rel_Generator_UserParentTable="InvestmentHouse" msprop:rel_Generator_ParentPropName="InvestmentHouseRow" msprop:rel_Generator_ChildPropName="GetCommissionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Commission" />
      <xs:field xpath="mstns:InvestmentHouseID" />
    </xs:keyref>
    <xs:keyref name="FK_Commission_Action" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_Commission_Action" msprop:rel_Generator_RelationVarName="relationFK_Commission_Action" msprop:rel_Generator_UserChildTable="Commission" msprop:rel_Generator_UserParentTable="Action" msprop:rel_Generator_ParentPropName="ActionRow" msprop:rel_Generator_ChildPropName="GetCommissionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Commission" />
      <xs:field xpath="mstns:ActionID" />
    </xs:keyref>
    <xs:keyref name="FK_Commission_Currency" refer="Currency_Constraint1" msprop:rel_Generator_UserRelationName="FK_Commission_Currency" msprop:rel_Generator_RelationVarName="relationFK_Commission_Currency" msprop:rel_Generator_UserChildTable="Commission" msprop:rel_Generator_UserParentTable="Currency" msprop:rel_Generator_ParentPropName="CurrencyRow" msprop:rel_Generator_ChildPropName="GetCommissionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:Commission" />
      <xs:field xpath="mstns:CurrencyCode" />
    </xs:keyref>
    <xs:keyref name="FK_CashTransaction_Currency" refer="Currency_Constraint1" msprop:rel_Generator_UserRelationName="FK_CashTransaction_Currency" msprop:rel_Generator_RelationVarName="relationFK_CashTransaction_Currency" msprop:rel_Generator_UserChildTable="CashTransaction" msprop:rel_Generator_UserParentTable="Currency" msprop:rel_Generator_ParentPropName="CurrencyRow" msprop:rel_Generator_ChildPropName="GetCashTransactionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:CashTransaction" />
      <xs:field xpath="mstns:CurrencyCode" />
    </xs:keyref>
    <xs:keyref name="FK_CashTransaction_CashAction" refer="CashAction_Constraint1" msprop:rel_Generator_UserRelationName="FK_CashTransaction_CashAction" msprop:rel_Generator_RelationVarName="relationFK_CashTransaction_CashAction" msprop:rel_Generator_UserChildTable="CashTransaction" msprop:rel_Generator_UserParentTable="CashAction" msprop:rel_Generator_ParentPropName="CashActionRow" msprop:rel_Generator_ChildPropName="GetCashTransactionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:CashTransaction" />
      <xs:field xpath="mstns:ActionID" />
    </xs:keyref>
    <xs:keyref name="FK_CashTransaction_CashPortfolio" refer="CashPortfolio_Constraint1" msprop:rel_Generator_UserRelationName="FK_CashTransaction_CashPortfolio" msprop:rel_Generator_RelationVarName="relationFK_CashTransaction_CashPortfolio" msprop:rel_Generator_UserChildTable="CashTransaction" msprop:rel_Generator_UserParentTable="CashPortfolio" msprop:rel_Generator_ParentPropName="CashPortfolioRow" msprop:rel_Generator_ChildPropName="GetCashTransactionRows" msdata:UpdateRule="None" msdata:DeleteRule="None">
      <xs:selector xpath=".//mstns:CashTransaction" />
      <xs:field xpath="mstns:CashPotfolioID" />
    </xs:keyref>
  </xs:element>
</xs:schema>